package com.comum.javahomework420242025.mapper;

import com.comum.javahomework420242025.pojo.ChanceAndClientForResult;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ChanceAndClientMapper {
    @Select("select *, clientcompany.comment as comment_client, clientcompany.areaname as areaname_client from chance join clientcompany on " +
            "chance.clientcompanyid=clientcompany.id")
    List<ChanceAndClientForResult> getAllChanceAndClient();
}
